﻿-- =============================================
-- Script Template
-- =============================================
GRANT EXECUTE ON [StoreSensorTelegram] TO [SensorDataWriter]
GO

GRANT EXECUTE ON [GetLatestSensorTelegram] TO [SensorDataReader]
GO


CREATE USER [EnOceanService]
    FOR LOGIN EnOceanService
    WITH DEFAULT_SCHEMA = dbo;
 go

EXEC sp_addrolemember N'SensorDataWriter', N'EnOceanService'
GO

EXEC sp_addrolemember N'SensorDataReader', N'EnOceanService'
GO
